﻿CREATE TABLE [dbo].[Products]
(
	ProductId int IDENTITY(1,1) NOT NULL, 
	CategoryId int NOT NULL,
	Name varchar(30) NOT NULL,
	SmallDescription varchar(300) NULL,
	Picture UniqueIdentifier NULL,
	Price Money NOT NULL,
	Quantity int NOT NULL default(1),
	Remarked bit default(0),
	Visible bit DEFAULT(1) NOT NULL

CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED (
	[ProductId] ASC
)
	WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]